How to: Name a formula.

Solution:


Copy the formula from the 'Formula Bar' and paste it into the 'Refers to' box of the 'Define Name' dialog box. Type a name for the formula in the 'Names in Workbook' box.